Agent Central Host Computer/Agent - Central Host Computer.iso/_SETUP.1/vshiftmoney.sql

Text File | 2000-05-12 | 999b | 24 lines

/*
This view collects all shift start and end records together with money accepted data.
*/
create or replace view vshiftmoney as
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, SHIFT_SEQ, USER_ID, ROUTE_ID,
 RUN_ID, TRIP_ID, FARESET_ID ,  0 alarm, 0 cash, 'Shift Start' event
from shftstrt
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, SHIFT_SEQ, USER_ID, ROUTE_ID,
 RUN_ID, TRIP_ID, FARESET_ID ,0 alarm, 0 cash,  'Shift End  ' event
from shftend
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, SHIFT_SEQ, USER_ID , 0 ROUTE_ID,
 0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , 0 alarm,0 cash, 'ShiftRelStart' event
from shftrels
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, SHIFT_SEQ, USER_ID , 0 ROUTE_ID,
 0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID ,0 alarm,0 cash, 'ShiftRelEnd  ' event
from shftrele
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
 0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , 1 alarm, currency_val cash, 'Money' event
from curacc;